package cn.t.dto.order;

import cn.t.utils.ExcelValid;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;

@Data
public class ExcelReconciliationAddDTO extends ExcelBaseDTO implements Serializable {

    /**
     * 领料员名称
     */
    @ExcelProperty(value = "订单sn")
    @ColumnWidth(25)
    private String orderSn;

    @ExcelProperty(value = "关联工单号")
    private String workOrderSn;

    @ExcelProperty(value = "下单时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date orderTime;

    @ExcelProperty(value = "设备名称")
    private String deviceName;

    @ExcelProperty(value = "设备编号")
    private Long deviceId;

    @ExcelProperty(value = "领用人姓名")
    private String userName;

    @ExcelProperty(value = "领用人工号")
    private String emp;

    @ExcelProperty(value = "物料名称")
    private String skuName;

    @ExcelProperty(value = "*sku")
    @ExcelValid(name="sku",msg = "必填")
    private String skuCode;

    @ExcelProperty(value = "客户物料号")
    private String customerSkuCode;

    @ExcelProperty(value = "备注")
    private String remark;

    @ExcelProperty(value = "工单申请数量")
    private Integer requestQty;

    @ExcelProperty(value = "单价（未税)")
    private BigDecimal unitPrice;

    @ExcelProperty(value = "*实际结算数量")
    @ExcelValid(name="实际结算数量",msg = "必填")
    private Integer actualQty;

    @ExcelProperty(value = "实际结算金额（未税）")
    private BigDecimal amount;

    @ExcelProperty(value = "是否是线下单(0:非线下单 1:线下单)")
    private Integer isOffline;



}
